package accounting.trade.model.dao;

import java.sql.SQLException;
import java.util.List;

import accounting.customer.model.vo.CustomerVO;
import accounting.trade.model.vo.ItemVO;
import accounting.trade.model.vo.ProductVO;
import accounting.trade.model.vo.TradeVO;
import accounting.trade.model.vo.WarehouseItemVO;

public interface TradeDao {
	public void insert_trade_info(TradeVO vo) throws SQLException;

	public void insert_warehouseitem(TradeVO vo) throws SQLException;

	public Object wareitem_seq() throws SQLException;

	void selectwareitem(TradeVO vo) throws SQLException;

	List customerlist() throws SQLException;

	List customerlistvalue(String value) throws SQLException;

	List warehouselistvalue(String value) throws SQLException;

	List warehouselist() throws SQLException;

	public List itemlist() throws SQLException;

	public List itemlistvalue(String value) throws SQLException;

	WarehouseItemVO getwareitem(int ware, int item) throws SQLException;

	void delete_warehouseitem(int i) throws SQLException;

	void update_warehouseitem(TradeVO vo) throws SQLException;

	Object product_seq() throws SQLException;

	void insert_producttrade_buy(ProductVO vo) throws SQLException;

	void insert_producttrade_sell(ProductVO vo) throws SQLException;

	Object index_seq() throws SQLException;

	Object countinfo() throws SQLException;

	List getTradeInfo(int page) throws SQLException;

	void stockinput(double c_stock) throws SQLException;

	Object getstock() throws SQLException;

	Object getItemPrice(int item_code) throws SQLException;

	public Object getOpeningBlance() throws SQLException;

	public void updateBlance(double blance) throws SQLException;

	Object checkBlance(int item_code) throws SQLException;

	List getBuyInfo(String time) throws SQLException;

	List getSellInfo(String time) throws SQLException;

}
